<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html 
     PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <title>Class: RelatoriosController</title>
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  <meta http-equiv="Content-Script-Type" content="text/javascript" />
  <link rel="stylesheet" href=".././rdoc-style.css" type="text/css" media="screen" />
  <script type="text/javascript">
  // <![CDATA[

  function popupCode( url ) {
    window.open(url, "Code", "resizable=yes,scrollbars=yes,toolbar=no,status=no,height=150,width=400")
  }

  function toggleCode( id ) {
    if ( document.getElementById )
      elem = document.getElementById( id );
    else if ( document.all )
      elem = eval( "document.all." + id );
    else
      return false;

    elemStyle = elem.style;
    
    if ( elemStyle.display != "block" ) {
      elemStyle.display = "block"
    } else {
      elemStyle.display = "none"
    }

    return true;
  }
  
  // Make codeblocks hidden by default
  document.writeln( "<style type=\"text/css\">div.method-source-code { display: none }</style>" )
  
  // ]]>
  </script>

</head>
<body>



    <div id="classHeader">
        <table class="header-table">
        <tr class="top-aligned-row">
          <td><strong>Class</strong></td>
          <td class="class-name-in-header">RelatoriosController</td>
        </tr>
        <tr class="top-aligned-row">
            <td><strong>In:</strong></td>
            <td>
                <a href="../files/app/controllers/relatorios_controller_rb.html">
                app/controllers/relatorios_controller.rb
                </a>
        <br />
            </td>
        </tr>

        <tr class="top-aligned-row">
            <td><strong>Parent:</strong></td>
            <td>
                <a href="ApplicationController.html">
                ApplicationController
               </a>
            </td>
        </tr>
        </table>
    </div>
  <!-- banner header -->

  <div id="bodyContent">



  <div id="contextContent">



   </div>

    <div id="method-list">
      <h3 class="section-bar">Methods</h3>

      <div class="name-list">
      <a href="#M000176">create</a>&nbsp;&nbsp;
      <a href="#M000177">destroy</a>&nbsp;&nbsp;
      <a href="#M000174">new</a>&nbsp;&nbsp;
      <a href="#M000175">show</a>&nbsp;&nbsp;
      </div>
    </div>

  </div>


    <!-- if includes -->

    <div id="section">





      


    <!-- if method_list -->
    <div id="methods">
      <h3 class="section-bar">Public Instance methods</h3>

      <div id="method-M000176" class="method-detail">
        <a name="M000176"></a>

        <div class="method-heading">
          <a href="#M000176" class="method-signature">
          <span class="method-name">create</span><span class="method-args">()</span>
          </a>
        </div>
      
        <div class="method-description">
          <p><a class="source-toggle" href="#"
            onclick="toggleCode('M000176-source');return false;">[Source]</a></p>
          <div class="method-source-code" id="M000176-source">
<pre>
    <span class="ruby-comment cmt"># File app/controllers/relatorios_controller.rb, line 33</span>
33:   <span class="ruby-keyword kw">def</span> <span class="ruby-identifier">create</span>
34:     <span class="ruby-ivar">@relatorio</span> = <span class="ruby-constant">Relatorio</span>.<span class="ruby-identifier">new</span>(<span class="ruby-identifier">params</span>[<span class="ruby-identifier">:relatorio</span>])
35:     <span class="ruby-ivar">@relatorio</span>.<span class="ruby-identifier">usuario</span> = <span class="ruby-constant">Usuario</span>.<span class="ruby-identifier">find</span>(<span class="ruby-constant">Goldberg</span>.<span class="ruby-identifier">user</span>)
36:     <span class="ruby-ivar">@relatorio</span>.<span class="ruby-identifier">consulta</span> = <span class="ruby-identifier">params</span>[<span class="ruby-identifier">:consulta</span>]
37:     <span class="ruby-keyword kw">if</span> <span class="ruby-ivar">@relatorio</span>.<span class="ruby-identifier">save</span>
38:       <span class="ruby-identifier">flash</span>[<span class="ruby-identifier">:notice</span>] = <span class="ruby-value str">&quot;Relatório criado com sucesso&quot;</span>
39:       <span class="ruby-identifier">redirect_to</span>(<span class="ruby-identifier">:action</span> =<span class="ruby-operator">&gt;</span> <span class="ruby-value str">'new'</span>)
40:     <span class="ruby-keyword kw">else</span>
41:       <span class="ruby-identifier">render</span>(<span class="ruby-identifier">:action</span> =<span class="ruby-operator">&gt;</span> <span class="ruby-identifier">show</span>)
42:     <span class="ruby-keyword kw">end</span>
43:   <span class="ruby-keyword kw">end</span>
</pre>
          </div>
        </div>
      </div>

      <div id="method-M000177" class="method-detail">
        <a name="M000177"></a>

        <div class="method-heading">
          <a href="#M000177" class="method-signature">
          <span class="method-name">destroy</span><span class="method-args">()</span>
          </a>
        </div>
      
        <div class="method-description">
          <p><a class="source-toggle" href="#"
            onclick="toggleCode('M000177-source');return false;">[Source]</a></p>
          <div class="method-source-code" id="M000177-source">
<pre>
    <span class="ruby-comment cmt"># File app/controllers/relatorios_controller.rb, line 45</span>
45:   <span class="ruby-keyword kw">def</span> <span class="ruby-identifier">destroy</span>
46:     <span class="ruby-keyword kw">if</span> <span class="ruby-constant">Relatorio</span>.<span class="ruby-identifier">find</span>(<span class="ruby-identifier">params</span>[<span class="ruby-identifier">:id</span>]).<span class="ruby-identifier">destroy</span>
47:       <span class="ruby-identifier">flash</span>[<span class="ruby-identifier">:notice</span>] = <span class="ruby-value str">'Relatório excluído com sucesso'</span>
48:       <span class="ruby-identifier">redirect_to</span>(<span class="ruby-identifier">:action</span> =<span class="ruby-operator">&gt;</span> <span class="ruby-value str">'new'</span>)
49:     <span class="ruby-keyword kw">else</span>
50:       <span class="ruby-identifier">flash</span>[<span class="ruby-identifier">:error</span>] = <span class="ruby-value str">&quot;seu idiota!&quot;</span>
51:       <span class="ruby-identifier">render</span>(<span class="ruby-identifier">:action</span> =<span class="ruby-operator">&gt;</span> <span class="ruby-value str">'new'</span>)
52:     <span class="ruby-keyword kw">end</span>
53:   <span class="ruby-keyword kw">end</span>
</pre>
          </div>
        </div>
      </div>

      <div id="method-M000174" class="method-detail">
        <a name="M000174"></a>

        <div class="method-heading">
          <a href="#M000174" class="method-signature">
          <span class="method-name">new</span><span class="method-args">()</span>
          </a>
        </div>
      
        <div class="method-description">
          <p><a class="source-toggle" href="#"
            onclick="toggleCode('M000174-source');return false;">[Source]</a></p>
          <div class="method-source-code" id="M000174-source">
<pre>
   <span class="ruby-comment cmt"># File app/controllers/relatorios_controller.rb, line 3</span>
3:   <span class="ruby-keyword kw">def</span> <span class="ruby-identifier">new</span>
4:     <span class="ruby-ivar">@relatorios</span> = <span class="ruby-constant">Relatorio</span>.<span class="ruby-identifier">find</span>(<span class="ruby-identifier">:all</span>, <span class="ruby-identifier">:conditions</span> =<span class="ruby-operator">&gt;</span> [<span class="ruby-value str">&quot;usuario_id=?&quot;</span>, <span class="ruby-constant">Goldberg</span>.<span class="ruby-identifier">user</span>])
5:   <span class="ruby-keyword kw">end</span>
</pre>
          </div>
        </div>
      </div>

      <div id="method-M000175" class="method-detail">
        <a name="M000175"></a>

        <div class="method-heading">
          <a href="#M000175" class="method-signature">
          <span class="method-name">show</span><span class="method-args">()</span>
          </a>
        </div>
      
        <div class="method-description">
          <p><a class="source-toggle" href="#"
            onclick="toggleCode('M000175-source');return false;">[Source]</a></p>
          <div class="method-source-code" id="M000175-source">
<pre>
    <span class="ruby-comment cmt"># File app/controllers/relatorios_controller.rb, line 7</span>
 7:   <span class="ruby-keyword kw">def</span> <span class="ruby-identifier">show</span>
 8:     <span class="ruby-keyword kw">if</span> <span class="ruby-identifier">params</span>[<span class="ruby-identifier">:relatorio</span>].<span class="ruby-identifier">blank?</span>
 9:       <span class="ruby-ivar">@show_salvar</span> = <span class="ruby-keyword kw">true</span>
10:       <span class="ruby-keyword kw">if</span> <span class="ruby-identifier">params</span>[<span class="ruby-identifier">:usuario</span>].<span class="ruby-identifier">blank?</span> <span class="ruby-keyword kw">and</span> <span class="ruby-identifier">params</span>[<span class="ruby-identifier">:estado</span>].<span class="ruby-identifier">blank?</span>
11:         <span class="ruby-identifier">flash</span>[<span class="ruby-identifier">:warning</span>] = <span class="ruby-value str">&quot;Selecione ao menos um campo para gerar o relatório&quot;</span>
12:         <span class="ruby-identifier">redirect_to</span>(<span class="ruby-identifier">:action</span> =<span class="ruby-operator">&gt;</span> <span class="ruby-value str">'new'</span>)
13:       <span class="ruby-keyword kw">end</span>
14:       <span class="ruby-ivar">@consulta</span> = <span class="ruby-value str">&quot;SELECT * FROM requisicoes WHERE id is not null &quot;</span>
15:       <span class="ruby-keyword kw">unless</span> <span class="ruby-identifier">params</span>[<span class="ruby-identifier">:usuario</span>].<span class="ruby-identifier">blank?</span>
16:         <span class="ruby-ivar">@consulta</span> = <span class="ruby-ivar">@consulta</span> <span class="ruby-operator">+</span> <span class="ruby-value str">&quot;and usuario_id='&quot;</span> <span class="ruby-operator">+</span> <span class="ruby-identifier">params</span>[<span class="ruby-identifier">:usuario</span>] <span class="ruby-operator">+</span> <span class="ruby-value str">&quot;'&quot;</span>
17:       <span class="ruby-keyword kw">end</span>
18:       <span class="ruby-keyword kw">unless</span> <span class="ruby-identifier">params</span>[<span class="ruby-identifier">:estado</span>].<span class="ruby-identifier">blank?</span>
19:         <span class="ruby-ivar">@consulta</span> = <span class="ruby-ivar">@consulta</span> <span class="ruby-operator">+</span> <span class="ruby-value str">&quot;and estado='&quot;</span> <span class="ruby-operator">+</span> <span class="ruby-identifier">params</span>[<span class="ruby-identifier">:estado</span>] <span class="ruby-operator">+</span> <span class="ruby-value str">&quot;'&quot;</span>
20:       <span class="ruby-keyword kw">end</span>
21:       <span class="ruby-ivar">@consulta</span> = <span class="ruby-ivar">@consulta</span> <span class="ruby-operator">+</span> <span class="ruby-value str">&quot;;&quot;</span>
22:     <span class="ruby-keyword kw">else</span>
23:       <span class="ruby-ivar">@show_salvar</span> = <span class="ruby-keyword kw">false</span>
24:       <span class="ruby-ivar">@consulta</span> = <span class="ruby-constant">Relatorio</span>.<span class="ruby-identifier">find</span>(<span class="ruby-identifier">params</span>[<span class="ruby-identifier">:relatorio</span>]).<span class="ruby-identifier">consulta</span>
25:     <span class="ruby-keyword kw">end</span>
26:     <span class="ruby-ivar">@requisicoes</span> = <span class="ruby-constant">Requisicao</span>.<span class="ruby-identifier">find_by_sql</span>(<span class="ruby-ivar">@consulta</span>)
27:     <span class="ruby-keyword kw">if</span> <span class="ruby-ivar">@requisicoes</span>.<span class="ruby-identifier">empty?</span>
28:       <span class="ruby-identifier">flash</span>[<span class="ruby-identifier">:warning</span>] = <span class="ruby-value str">&quot;Nenhuma requisição encontrada&quot;</span>
29:       <span class="ruby-identifier">redirect_to</span>(<span class="ruby-identifier">:action</span> =<span class="ruby-operator">&gt;</span> <span class="ruby-value str">'new'</span>)
30:     <span class="ruby-keyword kw">end</span>
31:   <span class="ruby-keyword kw">end</span>
</pre>
          </div>
        </div>
      </div>


    </div>


  </div>


<div id="validator-badges">
  <p><small><a href="http://validator.w3.org/check/referer">[Validate]</a></small></p>
</div>

</body>
</html>